MICROSOFT 2000 MCDBA TRAINING CURRICULUM

  1. Exam 70-215: Installing, Configuring and Administering Microsoft Windows 2000 Server
  2. Exam 70-216: Implementing and Administering a Microsoft Windows 2000 Network Infrastructure
  3. Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
  4. Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

I. Exam 70-215: Installing, Configuring and Administering Microsoft Windows 2000 Server

  • Windows 2000 - New Features and Architecture
    • 3 Hours

  • Windows 2000 Installation
    • 5 Hours

  • Windows 2000 Administration
    • 3 Hours

  • Windows 2000 Users
    • 3.25 Hours

  • Windows 2000 - Groups and Terminal Services
    • 3.50 Hours

  • Windows 2000 - Files and Folders
    • 4 Hours

  • Windows 2000 - Advanced File and Folder Management
    • 3.75 Hours

  • Windows 2000 - Hardware Configuration & Optimization
    • 6.25 Hours

  • Windows 2000 - Storage and Printing
    • 5.50 Hours

  • Windows 2000 Events
    • 3 Hours

  • Windows 2000 - Backup and Recovery
    • 3.75 Hours

  • Windows 2000 - Group Policy
    • 6.25 Hours

  • Windows 2000 - Network Protocols and Remote Access
    • 3.25 Hours


    II. Exam 70-216: Implementing and Administering a Microsoft Windows 2000 Network Infrastructure

  • Windows 2000 Implementing a Network Infrastructure: Addressing and Naming Services
    • 4 Hours

  • Windows 2000 - Implementing a Network Infrastructure: IP Routing
    • 4 Hours

  • Windows 2000 - Implementing a Network Infrastructure: Security
    • 5.25 Hours

  • Windows 2000 - Implementing a Network Infrastructure: Network Protocols and Remote Access
    • 3.25 Hours


    III. Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition

  • Overview of SQL Server 2000
    • 1.75 Hours

  • Installing, Configuring and Upgrading SQL Server 2000
    • 2 Hours

  • SQL Server 2000 Databases
    • 1.75 Hours

  • Transferring and Transforming Data in SQL Server 2000
    • 1.50 Hours

  • Security in a Microsoft SQL Server 2000 Environment
    • 2 Hours

  • Managing SQL Server 2000 Databases
    • 2.75 Hours

  • Backing Up SQL Server 2000 Databases
    • 2.25 Hours

  • Restoring SQL Server 2000 Databases
    • 1.75 Hours

  • SQL Server 2000 Replication
    • 1.75 Hours

  • Monitoring SQL Server 2000 Performance
    • 1.50 Hours

  • SQL Server 2000 High Availability
    • 1 Hour

  • SQL Server 2000, XML and the Web
    • 1.50 Hours


    IV. Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

  • Overview of SQL Server 2000
    • 1.75 Hours

  • SQL Server 2000 Databases
    • 1.75 Hours

  • Designing and Implementing Security in SQL Server 2000
    • 1.25 Hours

  • The SQL Server 2000 Logical Data Model
    • 2.50 Hours

  • Using T-SQL in SQL Server 2000
    • 3 Hours

  • SQL Server 2000 Indexes
    • 2 Hours

  • SQL Server 2000 Programming and Business Logic
    • 2.75 Hours

  • SQL Server 2000 Transactions and Distributed Data
    • 1.75 Hours

  • Analyzing and Optimizing SQL Server 2000 Queries
    • 1.75 Hours

  • Transferring and Transforming Data in SQL Server 2000
    • 1.50 Hours

  • SQL Server 2000, XML and the Web
    • 1.50 Hours